Running the Audit_04 Detail Charges to GL report

The Detail Charges to GL report allows for validation of Cost Detail data by comparing the cost detail (chargeable items with a unit or total charge amount) by postdate to Patient Revenue on the General Ledger. This report is a department level report showing monthly charges and variances.

To run the Audit_04 Detail Charges to GL report:

  1. In the Explorer task pane, in the Libraries section, click Costing Reports > Data Import Validations and double-click Audit_04 Detail Charges to GL.

  2. Refresh variables by doing one of the following:

    • In the Main tab, in the Workbook Options section, click Refresh Data.

    • Press F9.

  3. In the Refresh Variables dialog, do the following, and press OK:

    Option Description
    Select Entity (leave blank for all) Select one or more entities.
    Select Calendar Year and Month Select the year and month.

The report populates Cost Detail Gross Charges for comparison to Financial Gross Charges (Costing GL) while calculating any variance value and percent.

You need to review and resolve variances between the cost detail and cost GL, and then re-import and rerun the validation reports.

When this data is compared to the data of the billing source system:

  • This should tie-out completely.
  • Differences could be due to filtering issues with source system extract creation.

    • NOTE: If these extracts do not match, you may need to update the extracts for Cost Detail.

  • There could also be timing differences in the financial billing system versus the encounter source system.